
<html>


    <head>
        <meta charset="utf-8">
        <title>Seguridad Bancaria</title> 

    </head>
    <body>

        

        <?php        
        echo "<table border=1>";        
        echo "<tr>";       
        echo "<td>Cod Sucursal</td>";        
        echo "<td>Ficha</td>";        
        echo "<td>Nombre</td>";        
        echo "<td>Status</td>";
        echo "<td>Fecha de ingreso</td>";
        echo "<td>Fecha de Egreso</td>";
        
        echo "</tr>";
        echo "Empleados por Status del Banco " ;
        echo "<tr>";  
        foreach ($query as $row) {
                       
            echo "<tr>";            
            echo "<td>" . $row->cod_s . "</td>";            
            echo "<td>" . $row->ficha . "</td>";           
            echo "<td>" . $row->nombre . "</td>";            
            echo "<td>" . $row->status . "</td>";  
            echo "<td>" . $row->f_ing . "</td>";  
            echo "<td>" . $row->f_egr . "</td>";
            
            echo "</tr>";            
        }        
        echo "</table>";      
        ?>
        <br></br>        
        
        <?php        
        echo "<table border=1>";        
        echo "<tr>";       
        echo "<td>Sucursales</td>"; 
        echo "<td>Nº Empleados</td>"; 
        echo "</tr>";
        echo "Numero de Empleados por Sucursal";
        echo "<tr>"; 
        define('contador', 0);
        foreach ($query2 as $row) {
                       
            echo "<tr>";            
            echo "<td>" . $row->cod_s . "</td>";            
            
            echo "<td>" . $row->n_emp . "</td>";           
            
            echo "</tr>";            
        }        
        echo "</table>";
        
        
        ?>
        

        &nbsp;&nbsp;
        <!--<input type= "submit" name = "atras" value= "Atras" formaction="http://localhost/trunk/Pr-bd1-ce/index.php/consultas"  > 
        -->
    </body>
</html>